SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetEmailSender]
	
	(
	@param_Admin_LoginID VARCHAR(50)
	)
	
AS
	/* SET NOCOUNT ON */
	
	SELECT id,emailaddress FROM dbo.JOL_EmailManagement_Sender WHERE Admin_LoginID=@param_Admin_LoginID ORDER BY  is_default DESC
	RETURN
GO
